package com.kyleromano.disgaea.sql;

/**
 * List of constants used by the Database in its various versions
 * Keep track of new values and which DB version they were introduced in via comments
 * V1+ means they were first introduced in version 1 of the database, V12+ means version 12
 * @author kromano
 *
 */
public class DBConstants {
	//Database Parameters
	public static final int    DBVER = 4;
	public static final String DBNAME="disgaeaTracker";
	public static final boolean CLEAR_DB_ON_START = false;
	//Tables V1+
	public static final String TCHARACTERS = "Characters";
	public static final String TJOBS = "Jobs";
	public static final String TCLASSES = "Classes";
	//Tables V2+
	public static final String TCHAPTER = "ChapterCompleted";
	//Tables V4+
	public static final String TSYSDATA = "SystemData";
	//Columns V1+
	public static final String CCID = "_id";					//Integer
	public static final String CCHARNAME = "characterName";		//Char(50)
	public static final String CLEVEL = "level";				//Integer
	public static final String CCLASSID = "classID";			//Integer
	public static final String CCLASSNAME = "className";		//Char(50)
	public static final String CJOBID = "jobID";				//Integer
	public static final String CJOBNAME = "jobName";			//Char(50)
	//Columns V2+
	public static final String CCLASSUNLOCKED = "unlocked";		//Boolean as Integer
	//Columns V3+
	public static final String CCURRENTCHAPTER = "currentChapter";
	//Columns V4+
	public static final String CSORTORDER = "sortOrder";
	public static final String CASCENDING = "ascendingDescending";
	//Views V1+
	public static final String VCHARACTER = "v_Character";
	//Views V2+
	public static final String VCLASS = "v_class";
	
	//Select Strings V2+
	public static final String SCLASSUNLOCK = "SELECT " +CCLASSID+ " AS _id, " +CCLASSUNLOCKED+ " FROM CLASSES";
}
